Thu 10 May 2007, 09:42Delegate Eva said...
Eva has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Formatting
How to remove a dot behind an 18 digit number without corrupting it into scientific number?
Thu 10 May 2007, 13:59Trainer Pete said...
RE: Formatting
Hi Eva, Thanks for your post; a number as large as an 18 digit number will need to be formatted to be a Number, (Format, Cells, Number - Number) with or without decimal places. If it is entered as a general number Excel will apply the scientific number value to it.
