Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-23-2019, 07:07 AM
Cafourques Cafourques is offline Numbers being formatted in columns Windows 7 32bit Numbers being formatted in columns Office 2019
Novice
Numbers being formatted in columns
 
Join Date: Jul 2019
Posts: 1
Cafourques is on a distinguished road
Question Numbers being formatted in columns


Each time I enter a number (for instance a cheque number) in a column, it changes to something else. How do i keep numbers as numbers please?
Reply With Quote
  #2  
Old 07-23-2019, 11:26 PM
ArviLaanemets ArviLaanemets is offline Numbers being formatted in columns Windows 8 Numbers being formatted in columns Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

You hardly do any math with those numbers?! So format the column as text! And then of-course all references to this column must be to text values too, of-course!


To change column format to text:
1. Select the whole column, and format it as text. (NB! entries are aligned to left when no alignation is applied, and cells are shown as in text format, but numbers really remain numbers at this step!);
2. Into some free column with General format enter formula like ="" & A2 (Replace cell reference with proper one to column you formatted as text before). Copy the formula down so all numbers you want to convert are included;
3. Copy all formulas. Right-click on topmost cell in range with numbers you want to convert, and select PasteSpecial, and then Values option;
4. Delete formulas you added before. It's done!
Reply With Quote
  #3  
Old 07-27-2019, 01:40 AM
Lugh's Avatar
Lugh Lugh is offline Numbers being formatted in columns Windows 10 Numbers being formatted in columns Office 2016
Competent Performer
 
Join Date: May 2019
Location: USA
Posts: 137
Lugh is on a distinguished road
Default

Quote:
Originally Posted by Cafourques View Post
How do i keep numbers as numbers please?
As Arvi says, your example isn't a number. It's text which happens to include numerals, eg 123 Main St #7. So format those as text.

I find Excel is pretty good at keeping numbers as numbers. Special kinds of numbers, like currency, percents & dates, will usually require an extra formatting step to select how you want them displayed—eg July 27 or 2019-07-27 or…
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unwanted blank page at end of doc formatted into columns btse1 Word 4 05-02-2018 04:14 PM
Numbers being formatted in columns Row was formatted as % - reformat? Officer_Bierschnitt Excel 4 11-12-2015 06:59 AM
Macro to keep formatted form fields after mail merge or replace text with formatted form fields jer85 Word VBA 2 04-05-2015 10:00 PM
Numbers being formatted in columns My documents have been re-formatted??? Davec666 Word 2 04-30-2013 08:40 AM
Numbers being formatted in columns How to compare 2 columns with other two columns in EXECL 2007? Learner7 Excel 5 06-12-2010 09:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:09 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft