Quote:
Originally posted by Paul James
Quote: Originally posted by antonye
You may need to set the cell formatting on the range once you've copied the formulas over. Excel can be funny like this sometimes as it constantly tries to do a "best guess" about the formatting of a cell when the contents change. It's a right pita for us developers! |
Spot on again; it tried to set the format to Greek for some of the cells !! All sorted now so I'm going to risk merging the database to my labels and inspection reports. |
Spoke too soon saved the database then tried to merge and the leading zeroes dissapeared. Checked the format again and the whole column has reformatted to Greek. Arghhhhh!!! Bl**dy Microsoft !!!!*"+***