how do I format numbers as text
for example
100 A-B 7 C-D 56 A-b 65 A-b |
how do I format numbers as text
Those are not numbers.
100 A-B in one cell is already text. What do you mean by your subject line? Gord Dibben MS Excel MVP On Mon, 18 Jan 2010 17:18:01 -0800, Brenda wrote: for example 100 A-B 7 C-D 56 A-b 65 A-b |
how do I format numbers as text
you can 'convert' it to text. by using =Text(cell, "General") the "General" is the format string you can find in the format dialog box, pick a format you like, click custom and you can copy and paste it. any number you add this ' before the formula and it become text. "Brenda" wrote: for example 100 A-B 7 C-D 56 A-b 65 A-b |
All times are GMT +1. The time now is 06:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com