Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
I need some help ...
I have a column of text that must always maintain a set # of characters (40) regardless of how short the text value is.
Is there a way to force spaces to be added ... ie formatting a cell that ensures there are always 40 characyers? Something like entering a number 23.45 into a cell formated as 000.0000 gives you 023.4500?
I have a column of text that must always maintain a set # of characters (40) regardless of how short the text value is.
Is there a way to force spaces to be added ... ie formatting a cell that ensures there are always 40 characyers? Something like entering a number 23.45 into a cell formated as 000.0000 gives you 023.4500?